don't click here

TSC Data Archiving Workbook


    Print

Author Topic: TSC Data Archiving Workbook  (Read 46227 times)

0 Members and 1 Guest are viewing this topic.

TSC Data Archiving Workbook
« on: October 22, 2008, 10:43:22 pm »
The Sonic Center Stats Recording Archive
Last Updated: 1-6-2009

Compatible with: Excel 98-2003, OpenOffice, Excel 2007

Features:
-Comprehensive index
-Areas to record all stats carried by TSC
-Separate worksheets for every game
-Color-coded character divisions
-Self-updating totals for all statistics
-Uniform design layout for all games
-Automatically skips over unused cells (Excel only)

Snapshots:





As a side note, the .xls version loads much faster than the .xlsx in OpenOffice.
« Last Edit: January 10, 2013, 11:40:39 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Offline Luxray

Re: TSC Data Archiving Workbook
« Reply #1 on: October 23, 2008, 01:12:13 am »
Now that's pretty useful. Not that i'll need it ._.
<+DsS|away> eat a dick
<+GerbilSoft> actually i could

<Umbreon> sleeping with cruizer is awesome

Re: TSC Data Archiving Workbook
« Reply #2 on: October 24, 2008, 01:44:13 am »
Charts updated. I had screwed up a few things here and there before, but I guess that's what happens for rushing the job <_< Regardless, all should be well in these fresh charts.

If anyone who decides to use these finds anything wrong with them, let me know.
« Last Edit: October 25, 2008, 10:32:56 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Offline Jawzunx

  • first person to beat Cybrax on City Escape (3rd mission)
  • TSC: Jawzun
  • win7 chrome
  • Posts: 141
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #3 on: October 24, 2008, 01:46:46 am »
Nice, but you still forgot about SA2B Bosses :/
And in SADX Red Mountain you put charts for Sonic, Tails, and Knuckles, when it should be Sonic - Knuckles - Gamma  :P
still can't believe what I did in 2007

Re: TSC Data Archiving Workbook
« Reply #4 on: October 24, 2008, 02:04:42 am »
Good catch, Jawzun. Fixed.
Never forget who you are.
DeviantART account: (link)

Offline SadisticMystic

Re: TSC Data Archiving Workbook
« Reply #5 on: October 24, 2008, 02:28:32 am »
Perhaps it would help to add totals, like these?

Also separate worksheets are pwn.

Re: TSC Data Archiving Workbook
« Reply #6 on: October 24, 2008, 02:49:45 am »
Perhaps it would help to add totals, like these?

Also separate worksheets are pwn.
I hadn't been sure how to handle times in Excel, so that had made totals a difficult concept at the time. Although I feel these charts are lacking without them, my main goal was to make an efficient, uniform archiving system for personal stats of all TSC games. I'll work on reformatting the time columns now that I know there's a method to do so, and will look into implementing totals again.

As for the multiple worksheets, I had considered it, but decided on an index in the end. If people are interested enough, I could make a version that uses multiple worksheets.
« Last Edit: October 24, 2008, 01:49:17 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Re: TSC Data Archiving Workbook
« Reply #7 on: October 24, 2008, 01:48:20 pm »
After a sleepless night's effort, this should be the final version. I gave the whole thing a major cosmetic overhaul, added some color coding to the divisions, gave every last game a totaling system, fixed a few minor errors I came across, and made it easier to navigate. I tried out putting things on separate worksheets, but couldn't decide on a good way to break them up. It would be easy enough to implement, though, if someone has a sorting system in mind.

As a side note, it appears the formulas I used for totaling aren't entirely compatible with older versions of Excel, though, along with a handful of conditions, so no compatibility version :/
« Last Edit: October 27, 2008, 08:19:37 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Offline EngiNerd

  • Most Sarcastic Member of the Year
  • TSC Profile
  • win7 chrome
  • Posts: 798
  • Hydrowhut
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #8 on: October 24, 2008, 04:55:27 pm »
You ain't done yet.  You need a .xls file.
/me would be bricked, but some Linux users will agree
Im in ur TSCz, climin ur chartz!
My presssioussss....

Re: TSC Data Archiving Workbook
« Reply #9 on: October 24, 2008, 05:40:25 pm »
You ain't done yet.  You need a .xls file.
/me would be bricked, but some Linux users will agree
I would, but as stated above, there's quite a few compatibility problems in this latest version between the two formats; it breaks several formulas and almost all of the coloring when switching to .xls. That's kind of annoying, but there's not much I can do about it at this point, unfortunately :(
Never forget who you are.
DeviantART account: (link)

Offline SadisticMystic

Re: TSC Data Archiving Workbook
« Reply #10 on: October 24, 2008, 05:44:44 pm »
So use .ods! The Other ISO-Approved Standard(tm)!

Offline EngiNerd

  • Most Sarcastic Member of the Year
  • TSC Profile
  • win7 chrome
  • Posts: 798
  • Hydrowhut
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #11 on: October 24, 2008, 05:53:49 pm »
SM: That's why I was asking for .xls - so OpenOffice could use it.  But, IIRC, even Office 2007 can't open .ods yet, nor can it save them.
Im in ur TSCz, climin ur chartz!
My presssioussss....

Re: TSC Data Archiving Workbook
« Reply #12 on: October 24, 2008, 06:58:46 pm »
I just downloaded OpenOffice a few minutes ago to experiment, and it was able to open excel 2007 files (Maybe it was just added recently?). Anyway, it still fried most of the conditional colors, but the formulas seem to be working just fine.
« Last Edit: October 27, 2008, 08:20:06 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Offline EngiNerd

  • Most Sarcastic Member of the Year
  • TSC Profile
  • win7 chrome
  • Posts: 798
  • Hydrowhut
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #13 on: October 24, 2008, 07:13:27 pm »
WHUT.
* Minus the Antiporcupine checks OpenOffice website
FINALLY.
Nice timing, Auriman.  According to the press release, OpenOffice supports MSOffice 2007 files as of ... last Monday.  No really, October 13th.  Nice find, I've been waiting for this ... well, since MSOffice 2007 came out.
Im in ur TSCz, climin ur chartz!
My presssioussss....

Re: TSC Data Archiving Workbook
« Reply #14 on: October 27, 2008, 08:23:45 pm »
You know how I said the other was the last version?
Thanks to my borderline-obsessive-compulsive personality, I lied.
See here for the latest version and preview snapshots.

Significant changes:
-All games are now on separate worksheets. Reason: maintenance of such a large database on a single worksheet was hell, not to mention it wasn’t the most user-friendly interface, upon reflection. The index is still present to make navigation between worksheets more convenient, however. You were right, SM: “multiple worksheets are pwn”
-Compatibility problems with Excel 98-2003 and OpenOffice have been fixed. This was done by getting rid of the garbage conditional formatting in favor of more traditional coloring methods, and breaking up formulas with over 30 variables into multiple values, then adding them together.
-SADX Sky Chase 1 and 2 scores have been added
-SA2B Time, Ring, and Score totals have been fixed, as they had been completely wrong. I don’t know what had happened there.
-Sonic2 Sonic and Knuckles totals have been fixed.

If anyone finds anything wrong with this latest version, let me know as soon as possible. I want this to be the defining standard of recording TSC stats off-site.

I also apologize to anyone who had started using the older versions of the archive. I should have been able to produce a quality database product right off the bat, without all this floundering about. I guess I’ll just think of this as a learning experience of why it’s important for me to thoroughly test any programs I make before releasing them to the public.

Speaking of programs, I put off three college programming assignments to make this over the past week, and they’re all due tomorrow. Oh shi-
« Last Edit: October 27, 2008, 09:33:28 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Offline EngiNerd

  • Most Sarcastic Member of the Year
  • TSC Profile
  • win7 chrome
  • Posts: 798
  • Hydrowhut
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #15 on: October 27, 2008, 08:47:53 pm »
Speaking of programs, I put off three college programming assignments to make this over the past week, and they’re all due tomorrow.
BROTHER!  :D
You computer science or computer engineering?
Im in ur TSCz, climin ur chartz!
My presssioussss....

Offline Shadow Jacky

  • -Proprietor of /d/-
  • Broseidon
  • TSC Profile
  • win81 firefox
  • Posts: 979
  • BEHOLD!
    • View Profile
    • I streams when on windows
Re: TSC Data Archiving Workbook
« Reply #16 on: October 27, 2008, 08:50:04 pm »
ANTI!

I sent you a PM!
my name has nothing to do with Shadow The Hedgehog

Completed Runs:
Sonic Heroes: Team Sonic: SS
Rocket Knight Adventures: Easy (US): SS

In the Future:
Aero The Acrobat (Genesis) | More...

Re: TSC Data Archiving Workbook
« Reply #17 on: October 27, 2008, 08:54:38 pm »
Speaking of programs, I put off three college programming assignments to make this over the past week, and they’re all due tomorrow.
BROTHER!  :D
You computer science or computer engineering?
I'm currently going for a degree in IT Computer Programming/Analysis :)

We're covering Visual Basic 2008 programs right now, and we'll be learning some Java next year. I might eventually do some independent study on C/C++, as well, since it seems to be the standard in coding for emulators and third-party games.
Never forget who you are.
DeviantART account: (link)

Offline yse

  • Thrower of Gauntlets
  • Architect emeritus
  • TSC: mike89
  • win10 chrome
  • Posts: 1723
  • Constitutions written: 1 and counting
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #18 on: October 28, 2008, 08:41:49 pm »
Looks like my pen-and-paper method of recording stats off-site just became obsolete.

...

Awesome!

(If you remember my trusty notebook, good on you. If you don't remember or weren't around, play TSCA - there's a reference to it in there.)

<3 Thorn.

Offline Aitamen

  • TSC Profile
  • win7 firefox
  • Posts: 1130
  • I am a follower of the immortal Dark Falz!
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #19 on: October 28, 2008, 09:03:16 pm »
yeah... I just scribbled in all the stats I've gotten since my unb&

totally beats the lots of pen-and-paper work I was doing...

very much kudos for all the time spent!
Year 33 — The Malkavians claim that their greatest practical joke happened during this year, when they perform a bit of graverobbing  in Jerusalem.
-- Vampire: The Masquerade

Offline Selphos

  • The Eternally Young Scarlet Moon
  • Broseidon
  • TSC: Sondow
  • win10 firefox
  • Posts: 980
  • TSC's local Touhou nut
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #20 on: October 28, 2008, 09:03:55 pm »
mike TSCA no longer exists. The link to it on TSC is dead, remember?

And I don't believe RPG kept any copies of it anywhere >_>

But yeah I will be picking this up for the sake of convenience. Even though I'm mostly idle on TSC.
The moon is so red. Looks like it's going to be a fun night.

Re: TSC Data Archiving Workbook
« Reply #21 on: November 26, 2008, 07:41:27 pm »
Charts Updated

11-26-2008 Changelog:

Workbook level change:
Seconds occasionally displayed incorrectly in time totals under certain conditions, which had to do with how hundredths/thousandths were carried over (ex: 82 instead of 22). Given it didn't affect the rest of the total (it still carried the minutes over from excess seconds properly), it was only a minor cosmetic issue that escaped my attention during the testing period. Fixed.

Worksheet level changes:
Advance2 - Added Boss divisions
Sonic06 - changed time slots and totals to manage thousandths
SSR - Skeleton Dome: Mission 4 score enabled
STT - Sunset Park 2 scores disabled
Sonic3D - Disabled hundredths in times division


For current users of the TSC DAW, here are some quick fix methods:

--To add the Advance2 Boss divisions, copy rows 80-128 from the new workbook, and insert them into the old one accordingly. Make sure the rows line up properly with the new version to ensure consistency with any future updates.

--To fix the seconds display error, substitute column K in every worksheet with the corresponding column K's in this new workbook. Timeframe: It should take less than 15 minutes from start to finish, if you're quick with the copy/paste work. I couldn't find a faster way than that, I apologize :[

--To change the totals for Sonic06 to handle thousandths properly, copy columns K through O from the new workbook to the previous version, then adjust the width of column F to provide space for three digits.

--To disable/enable cells, just re-format the individual cells accordingly; the totals will automatically adjust. For Excel users, remember to lock/unlock cells where appropriate.
Never forget who you are.
DeviantART account: (link)

Offline KnucklesSonic8

Re: TSC Data Archiving Workbook
« Reply #22 on: November 27, 2008, 02:07:33 pm »
Thanks for the update, bud. Checking it out now. This means a lot.
Wiiloveit

Current Competition Focus: ---
Wants S&S All-Stars Racing

Offline Selphos

  • The Eternally Young Scarlet Moon
  • Broseidon
  • TSC: Sondow
  • win10 firefox
  • Posts: 980
  • TSC's local Touhou nut
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #23 on: November 27, 2008, 03:49:06 pm »
So far this is coming along great, but I have a request for you. Could you make a version of this for TUSC at some point?
The moon is so red. Looks like it's going to be a fun night.

Re: TSC Data Archiving Workbook
« Reply #24 on: November 27, 2008, 04:25:11 pm »
So far this is coming along great, but I have a request for you. Could you make a version of this for TUSC at some point?
It'll probably take some time, but I'll look into it.
Never forget who you are.
DeviantART account: (link)

Offline KnucklesSonic8

Re: TSC Data Archiving Workbook
« Reply #25 on: November 27, 2008, 05:05:52 pm »
I can't download the attachment. :(
Wiiloveit

Current Competition Focus: ---
Wants S&S All-Stars Racing

Re: TSC Data Archiving Workbook
« Reply #26 on: December 02, 2008, 10:03:47 pm »
The aforementioned TUSC Data Archiving Workbook is complete, and can be found here.
Never forget who you are.
DeviantART account: (link)

Offline yse

  • Thrower of Gauntlets
  • Architect emeritus
  • TSC: mike89
  • win10 chrome
  • Posts: 1723
  • Constitutions written: 1 and counting
    • View Profile
Re: TSC Data Archiving Workbook
« Reply #27 on: January 06, 2009, 06:42:07 am »
I've finally got around to getting the latest version of this and have begun entering all the site records for the sake of archival. Since there's no site record total on-site (which I've said would be a good addition for years) this is an ideal place to calculate it. (I used to use SM's times.xls for this purpose.)

I've attached what I've done so far so that people can help me out if they feel like it. I've done up to SA2B so far, but I'm going to sleep and will work on it again tomorrow. You can also download it if you're curious on the totals of the games that've been done so far >_>

<3 Thorn.

Re: TSC Data Archiving Workbook
« Reply #28 on: January 06, 2009, 01:24:39 pm »
I suppose the least I can do is make a few much-needed updates.

1-6-2009 Changelog:

Added Unleashed charts for Wii/PS2 and 360
Heroes: Added Special divisions
SPA: Added Special divisions
Rush: Added Special divisions
SRA: Added Extra divisions
Minor edits in locking cells

Edit: Heroes scores removed


I've attached the yse's site records archive with these updates. I'll try to implement a master total calculator later, but I'm a little short on time right now.
« Last Edit: January 06, 2009, 07:24:42 pm by Auriman1 »
Never forget who you are.
DeviantART account: (link)

Offline FuzZerd

Re: TSC Data Archiving Workbook
« Reply #29 on: January 06, 2009, 06:42:07 pm »
why are their three decimal places in su360?

    Print
 


-- Back to Normal Skin --
Hits: 89 | Hits This Month: 2 | DB Calls: 5 | Mem Usage: 1.30 MB | Time: 0.07s | Printable

The Sonic Center v3.9
Copyright 2003-2011 by The Sonic Center Team.